Charts of Accounts

Charts of Accounts lists all of the charts of accountsNumbered lists of accounts, including the account codes and their names/descriptions, that make up the general ledgers of companies and that form the bases of trial balances. In General Ledger Manager, you must create a chart of accounts for each trial balance file that you will upload. To each chart of accounts, you must attach an import layout for each trial balance file. The charts of accounts and their import layouts will be applied to their respective trial balance files for file validation when the files are added to the application. that administrators have created for the trial balance files that will be uploaded to General Ledger Manager, and enables administrators to manage them and to create new ones. A chart of accounts may need to be created for each unique trial balance that will be added/uploaded.

How Charts of Accounts is Used

Charts from Charts of Accounts are used in Account Maps in Setup where you select one or more of them for inclusion in account mapsMaps that associate accounts in charts of accounts, which underly trial balance data files, to master accounts in a master chart of accounts. You must create and apply these maps to control how trial balance files are merged and summed in the creation of master trial balances. For example, you might map Petty Cash and Other Cash in a chart of accounts to the Cash master account in an account map. When trial balance files are merged to create a master trial balance, all of the Petty Cash and Other Cash accounts in the various files will be itemized and summed under Cash on the resulting master trial balance in accordance with the account map. that you are creating or editing. Only those charts of accounts will be available for selection, however, whose year is the same as the tax year that you selected for an account map.

Charts of accounts in the list are also used in the Add a File to Queue routine in Import Trial Balances where in the second step of the routine you must select the chart that applies to the trial balance file that you want to add to General Ledger Manager. The chart that you select will then be used for the file validation processThe process in which trial balance files have their file layouts checked against the import layout assigned to the chart of accounts used to add/upload them to the Import Queue. Also, the files are checked to ensure that they have no unknown account codes or reporting units in them..

If your organization licenses and uses General Ledger Manager connectA proprietary software utility created by Thomson Reuters, it enables General Ledger Manager to accept and upload trial balance files automatically. To use this feature, you must be licensed by Thomson Reuters, and an administrator must download the utility from Settings in General Ledger Manager and configure it for your installation. to automatically upload trial balance files, then General Ledger Manager will assign a chart from Charts of Accounts automatically to each trial balance uploaded based on a match between the file name prefixAll trial balance files uploaded to General Ledger Manager must be associated with a chart of accounts for file validation purposes. For the automatic upload of trial balance files, General Ledger Manager applies the correct chart of accounts to trial balance files by matching its file name prefix to the file name prefix in the names of incoming trial balance files. Therefore, if your trial balance files are automatically uploaded, you must enter a file name prefix on a chart of accounts that is unique and that matches that of the trial balance files to which you want the chart to be applied. File name prefixes must not include underscoring or the following special characters: \ / : ? " < > |. entered on a chart of accounts and the prefix of an uploaded trial balance file.

How Charts of Accounts is Sorted

The charts are listed in descending order by Most Recent Year Available. You can click the Most Recent Year Available column heading to toggle the list between descending and ascending order. No other sorts may be done on this list.

Data Displayed in Charts of Accounts

The chart of accounts name, its year, and the name of the import layoutAn import layout contains the unique file attributes of a trial balance file(s). These attributes include the delimiter used in the file and the starting row of its data. Also included are the column numbers/letters where the required trial balance data fields reside. Administrators assign import layouts to charts of accounts, and both are used together by the application to validate trial balance files as they are uploaded to the Import Queue. assigned to it display for each chart in the list. If your organization is using General Ledger Manager connectA proprietary software utility created by Thomson Reuters, it enables General Ledger Manager to accept and upload trial balance files automatically. To use this feature, you must be licensed by Thomson Reuters, and an administrator must download the utility from Settings in General Ledger Manager and configure it for your installation. and a file name prefixAll trial balance files uploaded to General Ledger Manager must be associated with a chart of accounts for file validation purposes. For the automatic upload of trial balance files, General Ledger Manager applies the correct chart of accounts to trial balance files by matching its file name prefix to the file name prefix in the names of incoming trial balance files. Therefore, if your trial balance files are automatically uploaded, you must enter a file name prefix on a chart of accounts that is unique and that matches that of the trial balance files to which you want the chart to be applied. File name prefixes must not include underscoring or the following special characters: \ / : ? " < > |. has been entered on a chart of accounts, then it will display as well.

In addition to viewing/searching the list of charts in this view, you can do all of the following:

• Create a chart of accounts by:

1. Clicking Create a chart of accounts.
2. Defining the chart of accounts for the trial balance to be uploaded/imported.
3. Selecting and assigning the import layout that reflects the file attributes of the trial balance to be uploaded/imported.

Each time you create a chart, General Ledger Manager returns you to the Chart of Accounts list view where you can see the new chart in the list.

• Control the list view by:

• Sorting the list.
• Grouping the items in the list by name or by year.

For more information on controlling the list view, see Working with the Interface.

• Edit a chart of accounts. Clicking the name of a chart of accounts in the Chart of Accounts list view puts you in the edit view.
• Delete a chart of accounts.